Executes any kind SQL update statement - this can be UPDATE, INSERT, DELETE or a DDL statement CREATE, DROP, ALTER.
For an INSERT statement the value of any auto-generated key is returned when a single record is inserted,
for any other INSERT, UPDATE or DELETE statement the number of rows updated is returned,
otherwise returns 0.
Example:
var stmt = "update categories where id = '"
+ fields.categoryId.value
+ "' set description = '"
+ fields.categoryDescription.value
+ "'";
services.database.executeGenericUpdateStatement("SAMPLES", stmt);
Example:
var stmt = "update categories where id = '" + fields.categoryId.value + "' set description = '" + fields.categoryDescription.value + "'"; services.database.executeGenericUpdateStatement("SAMPLES", stmt);